﻿IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'usp_UPDMS_CAR_INFO_Get_Car_Info')
	BEGIN
		DROP Procedure usp_UPDMS_CAR_INFO_Get_Car_Info
	END
GO

SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
GO
/******************************************************************************
**	Name : usp_UPDMS_CAR_INFO_Get_Car_Info
**	Desc : 차량아이디로 차량정보를 조회한다.
**	Test Exec Query : Exec usp_UPDMS_CAR_INFO_Get_Car_Info 'CAR01'
**	Called by : Car_Dac_UPDMS_CAR_INFO.cs
**	Program ID : Car1011m, Car1012m...
**	Auth : 송시명
**	Date : 2014-09-18
*******************************************************************************
**	Change History
*******************************************************************************
**	Date:		Author:		Description:
**	--------	--------	---------------------------------------
**			
*******************************************************************************/
CREATE PROC [dbo].[usp_UPDMS_CAR_INFO_Get_Car_Info]
@ls_car_id nvarchar(10)
AS
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
SET NOCOUNT ON

SELECT Seq,
       Car_Id,
       License_Plate,
       Model,
       Prod_Co,
       Gear,
       Fuel,
       Color,
       Make_Ym,
       Buying_Dt,
       Cc,
       Init_Distance,
       Use_Yn,
       Remark,
       Attach_File1,
       Attach_File1_Size
  FROM UPDMS_CAR_INFO WITH(NOLOCK)
 WHERE Car_Id = @ls_car_id

GO